價格：免費
檔案大小：1.9 GB
版本需求：OS X 10.10 或以上版本，64 位元處理器
支援語言：英語
Microsoft Excel is the most widespread, renowned spreadsheet app in the world. Once you have understood the thousands of features and functions Excel 2016 offers, you will have the tools to maximise your everyday performance both at work and at home.
The tutorials will get you up to speed with all you need to know about Microsoft Excel 2016. With over 145 videos and lessons designed to teach you Excel quickly, you will be able to master the software easily and efficiently.
Why choose It's Easy - for Microsoft Excel 2016:
- No internet connection needed - learn offline
- Course was created by a certified teacher
- Not youtube videos, exclusive content not found anywhere else
List of lessons:
MS Excel Beginner Course
Chapter 1 Basics Of MS Excel
Chapter 2 Basics Of MS Excel 2
Chapter 3 Calculate Average In Excel
Chapter 4 Calculate Sum In Excel
Chapter 5 Count The Cells Containing Numbers In Excel
Chapter 6 Count The Not Empty Containing Numbers In Excel
Chapter 7 Join Content Of Multiple Cells In One Cell In Excel
Chapter 8 Calculate Running Total In Excel
Chapter 9 Do Addition Of Numbers In Excel
Chapter 10 Do Subtraction Of Numbers In Excel
Chapter 11 Do Division Of Numbers In Excel
Chapter 12 Do Multiplication In Excel
Chapter 13 Calculate Percentage In Excel
Chapter 14 Countblank Cells In Excel
Chapter 15 IF Formula In Excel
Chapter 16 CountIF Formula In Excel
Chapter 17 Vlookup Formula In Excel
Chapter 18 Sumif Formula In Excel
Chapter 19 Hlookup Formula In Excel
Chapter 20 Averageif Formula In Excel
Chapter 21 Pivot Table In Excel
Chapter 22 Insert Comment In Excel
Chapter 23 Edit Comment In Excel
Chapter 24 Delete Comment In Excel
Chapter 25 Create Border In Excel
Chapter 26 Wrap Text In Excel
Chapter 27 Merge Cells In Excel
Chapter 28 Number Formatting In Excel
Chapter 29 Paste Special In Excel
Chapter 30 Sort In Excel
Chapter 31 Convert Columns To Rows In Excel
Chapter 32 Conditional Formatting Cells Rules In Excel
Chapter 33 Conditional Formatting Top Bottom In Excel
Chapter 34 Excel Bar Graph
Chapter 35 Excel Column Graph
Chapter 36 Create Pie Chart In Excel
Chapter 37 Calculate Hour Minute Seconds In Excel
Chapter 38 Use Date In Excel In Excel
Chapter 39 Use Month Function In Excel
Chapter 40 Use Dictionary In Excel
Chapter 41 Use Hyperlink In Excel
MS Excel Intermediate Course
Chapter 1 ABS Function
Chapter 2 Sumif Function
Chapter 3 Hlookup Function
Chapter 4 Vlookup Function
Chapter 5 Countif Function
Chapter 6 AverageIf Function
Chapter 7 AverageIfs Function
Chapter 8 AverageA Function
Chapter 9 Data Validation With Date
Chapter 10 Data Validation With List
Chapter 11 Data Validation With Time
Chapter 12 Data Validation With Numbers
Chapter 13 Sumproduct Function
Chapter 14 Rank Function
Chapter 15 Min Function
Chapter 16 Max Function
Chapter 17 Cell Function
Chapter 18 N Function
Chapter 19 Char Function
Chapter 20 Clean Function
Chapter 21 Code Function
Chapter 22 Exact Function
Chapter 23 Round Function
Chapter 24 Large Function
Chapter 25 Mode Function
Chapter 26 Median Function
Chapter 27 Vlookup Exact Function
Chapter 28 Hlookup Exact Function
Chapter 29 Remove Duplicates
Chapter 30 Create Random Numbers
Chapter 31 Change Text To Upper Case
Chapter 32 Change Text To Lower Case
Chapter 33 Change Text To Proper Case
Chapter 34 Add Password To Excel
Chapter 35 Send Email From Excel File
Chapter 36 Add Custom Background Image
Chapter 37 Zoom In Zoom Out
Chapter 38 Auto Fill Data
Chapter 39 Add Special Characters
Chapter 40 Change Color Of Border Line
Chalter 41 Change Theme
MS Excel Advanced Course
Chapter 1Multiple Vlookup In Excel
Chapter 3 Vlookup Highest Value In Excel
Chapter 2 Vlookup Lowest Value In Excel
Chapter 4 Vlookup Multiple Results In Excel
Chapter 5 Remove NA Error From Vlookup Results
Chapter 6 Vlookup With MID Formula In Excel
And +64 other advanced course lessons that can't be listed here due to character limitations on the App Store.
